Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 3001 |
| Missing cells | 2384 |
| Missing cells (%) | 5.7% |
| Duplicate rows | 5 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 328.4 KiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Categorical | 6 |
| Text | 1 |
| Dataset has 5 (0.2%) duplicate rows | Duplicates |
comments is highly overall correlated with customerNumber and 7 other fields | High correlation |
customerNumber is highly overall correlated with comments | High correlation |
employeeNumber is highly overall correlated with comments and 1 other fields | High correlation |
orderDate is highly overall correlated with comments and 2 other fields | High correlation |
orderNumber is highly overall correlated with comments | High correlation |
origin is highly overall correlated with comments and 1 other fields | High correlation |
priceEach is highly overall correlated with sales_amount | High correlation |
quantityOrdered is highly overall correlated with sales_amount | High correlation |
requiredDate is highly overall correlated with comments and 2 other fields | High correlation |
sales_amount is highly overall correlated with priceEach and 1 other fields | High correlation |
shippedDate is highly overall correlated with comments and 2 other fields | High correlation |
status is highly overall correlated with comments | High correlation |
orderDate is highly imbalanced (98.9%) | Imbalance |
shippedDate is highly imbalanced (95.9%) | Imbalance |
requiredDate is highly imbalanced (96.1%) | Imbalance |
status is highly imbalanced (78.8%) | Imbalance |
origin is highly imbalanced (73.2%) | Imbalance |
shippedDate has 142 (4.7%) missing values | Missing |
comments has 2242 (74.7%) missing values | Missing |
employeeNumber has 137 (4.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-06 15:21:06.895701 |
|---|---|
| Analysis finished | 2025-02-06 15:21:12.353255 |
| Duration | 5.46 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
orderNumber
Real number (ℝ)
High correlation
| Distinct | 326 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10260.509 |
| Minimum | 10100 |
|---|---|
| Maximum | 10425 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 10100 |
|---|---|
| 5-th percentile | 10117 |
| Q1 | 10181 |
| median | 10263 |
| Q3 | 10339 |
| 95-th percentile | 10407 |
| Maximum | 10425 |
| Range | 325 |
| Interquartile range (IQR) | 158 |
Descriptive statistics
| Standard deviation | 92.61975 |
|---|---|
| Coefficient of variation (CV) | 0.0090268181 |
| Kurtosis | -1.1828136 |
| Mean | 10260.509 |
| Median Absolute Deviation (MAD) | 80 |
| Skewness | 0.013978109 |
| Sum | 30791788 |
| Variance | 8578.418 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10360 | 18 | 0.6% |
| 10168 | 18 | 0.6% |
| 10386 | 18 | 0.6% |
| 10222 | 18 | 0.6% |
| 10275 | 18 | 0.6% |
| 10106 | 18 | 0.6% |
| 10165 | 18 | 0.6% |
| 10398 | 18 | 0.6% |
| 10332 | 18 | 0.6% |
| 10159 | 18 | 0.6% |
| Other values (316) | 2821 |
| Value | Count | Frequency (%) |
| 10100 | 4 | 0.1% |
| 10101 | 4 | 0.1% |
| 10102 | 2 | 0.1% |
| 10103 | 16 | |
| 10104 | 14 | |
| 10105 | 15 | |
| 10106 | 18 | |
| 10107 | 8 | |
| 10108 | 16 | |
| 10109 | 6 | 0.2% |
| Value | Count | Frequency (%) |
| 10425 | 14 | |
| 10424 | 6 | 0.2% |
| 10423 | 5 | 0.2% |
| 10422 | 2 | 0.1% |
| 10421 | 2 | 0.1% |
| 10420 | 13 | |
| 10419 | 15 | |
| 10418 | 9 | |
| 10417 | 6 | 0.2% |
| 10416 | 14 |
orderLineNumber
Real number (ℝ)
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4245252 |
| Minimum | 1 |
|---|---|
| Maximum | 18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 14 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.1968701 |
|---|---|
| Coefficient of variation (CV) | 0.65325763 |
| Kurtosis | -0.5203634 |
| Mean | 6.4245252 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.6036522 |
| Sum | 19280 |
| Variance | 17.613718 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 1 | 327 | |
| 2 | 311 | |
| 3 | 288 | |
| 4 | 273 | |
| 5 | 256 | |
| 6 | 239 | |
| 7 | 212 | 7.1% |
| 8 | 201 | 6.7% |
| 9 | 177 | 5.9% |
| 10 | 149 | 5.0% |
| Other values (8) | 568 |
| Value | Count | Frequency (%) |
| 1 | 327 | |
| 2 | 311 | |
| 3 | 288 | |
| 4 | 273 | |
| 5 | 256 | |
| 6 | 239 | |
| 7 | 212 | |
| 8 | 201 | |
| 9 | 177 | |
| 10 | 149 |
| Value | Count | Frequency (%) |
| 18 | 11 | 0.4% |
| 17 | 26 | 0.9% |
| 16 | 43 | 1.4% |
| 15 | 57 | 1.9% |
| 14 | 82 | |
| 13 | 101 | |
| 12 | 114 | |
| 11 | 134 | |
| 10 | 149 | |
| 9 | 177 |
orderDate
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.6 KiB |
| 0000-00-00 | |
|---|---|
| 2038-09-00 | 3 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0000-00-00 |
|---|---|
| 2nd row | 0000-00-00 |
| 3rd row | 0000-00-00 |
| 4th row | 0000-00-00 |
| 5th row | 0000-00-00 |
Common Values
| Value | Count | Frequency (%) |
| 0000-00-00 | 2998 | |
| 2038-09-00 | 3 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0000-00-00 | 2998 | |
| 2038-09-00 | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 23996 | |
| - | 6002 | 20.0% |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30010 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23996 | |
| - | 6002 | 20.0% |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30010 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23996 | |
| - | 6002 | 20.0% |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30010 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23996 | |
| - | 6002 | 20.0% |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 3 | < 0.1% |
shippedDate
Categorical
High correlation Imbalance Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 142 |
| Missing (%) | 4.7% |
| Memory size | 23.6 KiB |
| 0000-00-00 | |
|---|---|
| 2038-00-06 | 17 |
| 2038-09-07 | 3 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0000-00-00 |
|---|---|
| 2nd row | 0000-00-00 |
| 3rd row | 0000-00-00 |
| 4th row | 0000-00-00 |
| 5th row | 0000-00-00 |
Common Values
| Value | Count | Frequency (%) |
| 0000-00-00 | 2839 | |
| 2038-00-06 | 17 | 0.6% |
| 2038-09-07 | 3 | 0.1% |
| (Missing) | 142 | 4.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0000-00-00 | 2839 | |
| 2038-00-06 | 17 | 0.6% |
| 2038-09-07 | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 22789 | |
| - | 5718 | 20.0% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 8 | 20 | 0.1% |
| 6 | 17 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 28590 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 22789 | |
| - | 5718 | 20.0% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 8 | 20 | 0.1% |
| 6 | 17 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 28590 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 22789 | |
| - | 5718 | 20.0% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 8 | 20 | 0.1% |
| 6 | 17 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 28590 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 22789 | |
| - | 5718 | 20.0% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 8 | 20 | 0.1% |
| 6 | 17 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
requiredDate
Categorical
High correlation Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.6 KiB |
| 0000-00-00 | |
|---|---|
| 2038-00-08 | 17 |
| 2038-09-07 | 3 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0000-00-00 |
|---|---|
| 2nd row | 0000-00-00 |
| 3rd row | 0000-00-00 |
| 4th row | 0000-00-00 |
| 5th row | 0000-00-00 |
Common Values
| Value | Count | Frequency (%) |
| 0000-00-00 | 2981 | |
| 2038-00-08 | 17 | 0.6% |
| 2038-09-07 | 3 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0000-00-00 | 2981 | |
| 2038-00-08 | 17 | 0.6% |
| 2038-09-07 | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 23925 | |
| - | 6002 | 20.0% |
| 8 | 37 | 0.1% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30010 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23925 | |
| - | 6002 | 20.0% |
| 8 | 37 | 0.1% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30010 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23925 | |
| - | 6002 | 20.0% |
| 8 | 37 | 0.1% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30010 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23925 | |
| - | 6002 | 20.0% |
| 8 | 37 | 0.1% |
| 2 | 20 | 0.1% |
| 3 | 20 | 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
customerNumber
Real number (ℝ)
High correlation
| Distinct | 98 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 259.63912 |
| Minimum | 103 |
|---|---|
| Maximum | 496 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 103 |
|---|---|
| 5-th percentile | 121 |
| Q1 | 145 |
| median | 240 |
| Q3 | 353 |
| 95-th percentile | 473 |
| Maximum | 496 |
| Range | 393 |
| Interquartile range (IQR) | 208 |
Descriptive statistics
| Standard deviation | 118.40343 |
|---|---|
| Coefficient of variation (CV) | 0.4560308 |
| Kurtosis | -1.0888518 |
| Mean | 259.63912 |
| Median Absolute Deviation (MAD) | 99 |
| Skewness | 0.45561081 |
| Sum | 779177 |
| Variance | 14019.373 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 141 | 260 | 8.7% |
| 124 | 180 | 6.0% |
| 114 | 55 | 1.8% |
| 119 | 54 | 1.8% |
| 187 | 51 | 1.7% |
| 131 | 49 | 1.6% |
| 496 | 48 | 1.6% |
| 278 | 48 | 1.6% |
| 151 | 48 | 1.6% |
| 282 | 46 | 1.5% |
| Other values (88) | 2162 |
| Value | Count | Frequency (%) |
| 103 | 7 | 0.2% |
| 112 | 29 | 1.0% |
| 114 | 55 | 1.8% |
| 119 | 54 | 1.8% |
| 121 | 32 | 1.1% |
| 124 | 180 | |
| 128 | 22 | 0.7% |
| 129 | 21 | 0.7% |
| 131 | 49 | 1.6% |
| 141 | 260 |
| Value | Count | Frequency (%) |
| 496 | 48 | |
| 495 | 18 | 0.6% |
| 489 | 12 | 0.4% |
| 487 | 15 | 0.5% |
| 486 | 23 | |
| 484 | 15 | 0.5% |
| 475 | 13 | 0.4% |
| 473 | 8 | 0.3% |
| 471 | 23 | |
| 462 | 26 |
employeeNumber
Real number (ℝ)
High correlation Zeros
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1317.9487 |
| Minimum | 0 |
|---|---|
| Maximum | 1702 |
| Zeros | 137 |
| Zeros (%) | 4.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1165 |
| Q1 | 1216 |
| median | 1370 |
| Q3 | 1501 |
| 95-th percentile | 1612 |
| Maximum | 1702 |
| Range | 1702 |
| Interquartile range (IQR) | 285 |
Descriptive statistics
| Standard deviation | 326.34357 |
|---|---|
| Coefficient of variation (CV) | 0.24761478 |
| Kurtosis | 9.347836 |
| Mean | 1317.9487 |
| Median Absolute Deviation (MAD) | 134 |
| Skewness | -2.8477689 |
| Sum | 3955164 |
| Variance | 106500.13 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 1370 | 398 | |
| 1165 | 331 | |
| 1401 | 273 | |
| 1501 | 236 | 7.9% |
| 1504 | 220 | 7.3% |
| 1323 | 212 | 7.1% |
| 1612 | 186 | 6.2% |
| 1611 | 185 | 6.2% |
| 1337 | 177 | 5.9% |
| 1216 | 152 | 5.1% |
| Other values (5) | 631 |
| Value | Count | Frequency (%) |
| 0 | 137 | 4.6% |
| 1165 | 331 | |
| 1166 | 114 | 3.8% |
| 1188 | 124 | 4.1% |
| 1216 | 152 | 5.1% |
| 1286 | 142 | 4.7% |
| 1323 | 212 | |
| 1337 | 177 | |
| 1370 | 398 | |
| 1401 | 273 |
| Value | Count | Frequency (%) |
| 1702 | 114 | 3.8% |
| 1612 | 186 | |
| 1611 | 185 | |
| 1504 | 220 | |
| 1501 | 236 | |
| 1401 | 273 | |
| 1370 | 398 | |
| 1337 | 177 | |
| 1323 | 212 | |
| 1286 | 142 | 4.7% |
productCode
Text
| Distinct | 109 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.6 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.1102966 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | S24_3969 |
|---|---|
| 2nd row | S18_2248 |
| 3rd row | S18_1749 |
| 4th row | S18_4409 |
| 5th row | S18_2795 |
| Value | Count | Frequency (%) |
| s18_3232 | 53 | 1.8% |
| s18_3136 | 29 | 1.0% |
| s18_2238 | 29 | 1.0% |
| s24_2300 | 28 | 0.9% |
| s18_2319 | 28 | 0.9% |
| s50_1392 | 28 | 0.9% |
| s32_1268 | 28 | 0.9% |
| s18_1097 | 28 | 0.9% |
| s18_4668 | 28 | 0.9% |
| s12_1666 | 28 | 0.9% |
| Other values (99) | 2694 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 3414 | |
| 1 | 3030 | |
| S | 3001 | |
| _ | 3001 | |
| 4 | 2146 | |
| 8 | 2143 | |
| 0 | 1899 | |
| 3 | 1827 | |
| 7 | 1149 | 4.7% |
| 9 | 1003 | 4.1% |
| Other values (2) | 1726 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24339 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3414 | |
| 1 | 3030 | |
| S | 3001 | |
| _ | 3001 | |
| 4 | 2146 | |
| 8 | 2143 | |
| 0 | 1899 | |
| 3 | 1827 | |
| 7 | 1149 | 4.7% |
| 9 | 1003 | 4.1% |
| Other values (2) | 1726 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24339 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3414 | |
| 1 | 3030 | |
| S | 3001 | |
| _ | 3001 | |
| 4 | 2146 | |
| 8 | 2143 | |
| 0 | 1899 | |
| 3 | 1827 | |
| 7 | 1149 | 4.7% |
| 9 | 1003 | 4.1% |
| Other values (2) | 1726 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24339 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3414 | |
| 1 | 3030 | |
| S | 3001 | |
| _ | 3001 | |
| 4 | 2146 | |
| 8 | 2143 | |
| 0 | 1899 | |
| 3 | 1827 | |
| 7 | 1149 | 4.7% |
| 9 | 1003 | 4.1% |
| Other values (2) | 1726 |
status
Categorical
High correlation Imbalance
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.6 KiB |
| Shipped | |
|---|---|
| Cancelled | 79 |
| Resolved | 47 |
| On Hold | 44 |
| In Process | 42 |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.1149617 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Shipped |
|---|---|
| 2nd row | Shipped |
| 3rd row | Shipped |
| 4th row | Shipped |
| 5th row | Shipped |
Common Values
| Value | Count | Frequency (%) |
| Shipped | 2775 | |
| Cancelled | 79 | 2.6% |
| Resolved | 47 | 1.6% |
| On Hold | 44 | 1.5% |
| In Process | 42 | 1.4% |
| Disputed | 14 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| shipped | 2775 | |
| cancelled | 79 | 2.6% |
| resolved | 47 | 1.5% |
| on | 44 | 1.4% |
| hold | 44 | 1.4% |
| in | 42 | 1.4% |
| process | 42 | 1.4% |
| disputed | 14 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 5564 | |
| e | 3083 | |
| d | 2959 | |
| i | 2789 | |
| S | 2775 | |
| h | 2775 | |
| l | 249 | 1.2% |
| n | 165 | 0.8% |
| s | 145 | 0.7% |
| o | 133 | 0.6% |
| Other values (14) | 715 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21352 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 5564 | |
| e | 3083 | |
| d | 2959 | |
| i | 2789 | |
| S | 2775 | |
| h | 2775 | |
| l | 249 | 1.2% |
| n | 165 | 0.8% |
| s | 145 | 0.7% |
| o | 133 | 0.6% |
| Other values (14) | 715 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21352 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 5564 | |
| e | 3083 | |
| d | 2959 | |
| i | 2789 | |
| S | 2775 | |
| h | 2775 | |
| l | 249 | 1.2% |
| n | 165 | 0.8% |
| s | 145 | 0.7% |
| o | 133 | 0.6% |
| Other values (14) | 715 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21352 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 5564 | |
| e | 3083 | |
| d | 2959 | |
| i | 2789 | |
| S | 2775 | |
| h | 2775 | |
| l | 249 | 1.2% |
| n | 165 | 0.8% |
| s | 145 | 0.7% |
| o | 133 | 0.6% |
| Other values (14) | 715 | 3.3% |
comments
Categorical
High correlation Missing
| Distinct | 37 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 2242 |
| Missing (%) | 74.7% |
| Memory size | 23.6 KiB |
| They want to reevaluate their terms agreement with Finance. | |
|---|---|
| Customer requested that DHL is used for this shipping | |
| Customer requested that FedEx Ground is used for this shipping | 43 |
| Custom shipping instructions sent to warehouse | 38 |
| Customer credit limit exceeded. Will ship when a payment is received. | 38 |
| Other values (32) |
Length
| Max length | 189 |
|---|---|
| Median length | 123 |
| Mean length | 83.646904 |
| Min length | 22 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check on availability. |
|---|---|
| 2nd row | Check on availability. |
| 3rd row | Check on availability. |
| 4th row | Check on availability. |
| 5th row | Difficult to negotiate with customer. We need more marketing materials |
Common Values
| Value | Count | Frequency (%) |
| They want to reevaluate their terms agreement with Finance. | 70 | 2.3% |
| Customer requested that DHL is used for this shipping | 64 | 2.1% |
| Customer requested that FedEx Ground is used for this shipping | 43 | 1.4% |
| Custom shipping instructions sent to warehouse | 38 | 1.3% |
| Customer credit limit exceeded. Will ship when a payment is received. | 38 | 1.3% |
| Customer very concerned about the exact color of the models. There is high risk that he may dispute the order because there is a slight color mismatch | 35 | 1.2% |
| Check on availability. | 34 | 1.1% |
| Can we deliver the new Ford Mustang models by end-of-quarter? | 33 | 1.1% |
| Customer requested special shippment. The instructions were passed along to the warehouse | 32 | 1.1% |
| Cautious optimism. We have happy customers here, if we can keep them well stocked. I need all the information I can get on the planned shippments of Porches | 28 | 0.9% |
| Other values (27) | 344 | 11.5% |
| (Missing) | 2242 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| the | 557 | 5.3% |
| customer | 478 | 4.6% |
| is | 289 | 2.8% |
| to | 284 | 2.7% |
| this | 255 | 2.4% |
| of | 241 | 2.3% |
| we | 226 | 2.2% |
| with | 198 | 1.9% |
| their | 186 | 1.8% |
| that | 177 | 1.7% |
| Other values (216) | 7529 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9694 | ||
| e | 7457 | 11.7% |
| t | 4787 | 7.5% |
| s | 4010 | 6.3% |
| i | 3574 | 5.6% |
| o | 3411 | 5.4% |
| r | 3324 | 5.2% |
| a | 3089 | 4.9% |
| h | 2769 | 4.4% |
| n | 2717 | 4.3% |
| Other values (47) | 18656 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 63488 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9694 | ||
| e | 7457 | 11.7% |
| t | 4787 | 7.5% |
| s | 4010 | 6.3% |
| i | 3574 | 5.6% |
| o | 3411 | 5.4% |
| r | 3324 | 5.2% |
| a | 3089 | 4.9% |
| h | 2769 | 4.4% |
| n | 2717 | 4.3% |
| Other values (47) | 18656 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 63488 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9694 | ||
| e | 7457 | 11.7% |
| t | 4787 | 7.5% |
| s | 4010 | 6.3% |
| i | 3574 | 5.6% |
| o | 3411 | 5.4% |
| r | 3324 | 5.2% |
| a | 3089 | 4.9% |
| h | 2769 | 4.4% |
| n | 2717 | 4.3% |
| Other values (47) | 18656 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 63488 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9694 | ||
| e | 7457 | 11.7% |
| t | 4787 | 7.5% |
| s | 4010 | 6.3% |
| i | 3574 | 5.6% |
| o | 3411 | 5.4% |
| r | 3324 | 5.2% |
| a | 3089 | 4.9% |
| h | 2769 | 4.4% |
| n | 2717 | 4.3% |
| Other values (47) | 18656 |
quantityOrdered
Real number (ℝ)
High correlation
| Distinct | 61 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.211929 |
| Minimum | 6 |
|---|---|
| Maximum | 97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 27 |
| median | 35 |
| Q3 | 43 |
| 95-th percentile | 49 |
| Maximum | 97 |
| Range | 91 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 9.8289574 |
|---|---|
| Coefficient of variation (CV) | 0.27913715 |
| Kurtosis | 0.69438677 |
| Mean | 35.211929 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.42453422 |
| Sum | 105671 |
| Variance | 96.608404 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34 | 122 | 4.1% |
| 31 | 108 | 3.6% |
| 21 | 108 | 3.6% |
| 46 | 104 | 3.5% |
| 33 | 104 | 3.5% |
| 27 | 104 | 3.5% |
| 45 | 100 | 3.3% |
| 29 | 100 | 3.3% |
| 41 | 100 | 3.3% |
| 48 | 99 | 3.3% |
| Other values (51) | 1952 |
| Value | Count | Frequency (%) |
| 6 | 2 | 0.1% |
| 10 | 3 | 0.1% |
| 11 | 2 | 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 15 | 4 | 0.1% |
| 16 | 1 | < 0.1% |
| 18 | 3 | 0.1% |
| 19 | 2 | 0.1% |
| 20 | 96 |
| Value | Count | Frequency (%) |
| 97 | 1 | < 0.1% |
| 90 | 1 | < 0.1% |
| 85 | 1 | < 0.1% |
| 77 | 2 | 0.1% |
| 76 | 3 | |
| 70 | 2 | 0.1% |
| 66 | 5 | |
| 65 | 2 | 0.1% |
| 64 | 4 | |
| 62 | 1 | < 0.1% |
priceEach
Real number (ℝ)
High correlation
| Distinct | 1573 |
|---|---|
| Distinct (%) | 52.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.765831 |
| Minimum | 26.55 |
|---|---|
| Maximum | 214.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 26.55 |
|---|---|
| 5-th percentile | 38.98 |
| Q1 | 62 |
| median | 85.76 |
| Q3 | 114.65 |
| 95-th percentile | 158.63 |
| Maximum | 214.3 |
| Range | 187.75 |
| Interquartile range (IQR) | 52.65 |
Descriptive statistics
| Standard deviation | 36.579368 |
|---|---|
| Coefficient of variation (CV) | 0.40300813 |
| Kurtosis | 0.081135768 |
| Mean | 90.765831 |
| Median Absolute Deviation (MAD) | 25.76 |
| Skewness | 0.64302467 |
| Sum | 272388.26 |
| Variance | 1338.0502 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 98.48 | 8 | 0.3% |
| 117.48 | 8 | 0.3% |
| 56.55 | 7 | 0.2% |
| 89.38 | 6 | 0.2% |
| 62 | 6 | 0.2% |
| 153 | 6 | 0.2% |
| 43.27 | 6 | 0.2% |
| 67.03 | 6 | 0.2% |
| 120.53 | 6 | 0.2% |
| 137.17 | 6 | 0.2% |
| Other values (1563) | 2936 |
| Value | Count | Frequency (%) |
| 26.55 | 2 | |
| 27.22 | 1 | < 0.1% |
| 27.55 | 1 | < 0.1% |
| 27.88 | 4 | |
| 28.64 | 2 | |
| 28.88 | 2 | |
| 29.21 | 1 | < 0.1% |
| 29.35 | 2 | |
| 29.54 | 1 | < 0.1% |
| 29.87 | 4 |
| Value | Count | Frequency (%) |
| 214.3 | 3 | |
| 212.16 | 1 | < 0.1% |
| 210.01 | 1 | < 0.1% |
| 207.87 | 1 | < 0.1% |
| 207.8 | 1 | < 0.1% |
| 205.73 | 4 | |
| 205.72 | 2 | |
| 203.64 | 1 | < 0.1% |
| 203.59 | 2 | |
| 201.57 | 2 |
sales_amount
Real number (ℝ)
High correlation
| Distinct | 2885 |
|---|---|
| Distinct (%) | 96.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3204.9084 |
| Minimum | 481.5 |
|---|---|
| Maximum | 11503.14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.6 KiB |
Quantile statistics
| Minimum | 481.5 |
|---|---|
| 5-th percentile | 1166.16 |
| Q1 | 1988.7 |
| median | 2880.48 |
| Q3 | 4093.6 |
| 95-th percentile | 6366 |
| Maximum | 11503.14 |
| Range | 11021.64 |
| Interquartile range (IQR) | 2104.9 |
Descriptive statistics
| Standard deviation | 1631.357 |
|---|---|
| Coefficient of variation (CV) | 0.50901828 |
| Kurtosis | 1.5215921 |
| Mean | 3204.9084 |
| Median Absolute Deviation (MAD) | 1012.5 |
| Skewness | 1.1049456 |
| Sum | 9617930.2 |
| Variance | 2661325.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2462 | 3 | 0.1% |
| 4212 | 3 | 0.1% |
| 3357.75 | 2 | 0.1% |
| 3213 | 2 | 0.1% |
| 1679.92 | 2 | 0.1% |
| 1584.44 | 2 | 0.1% |
| 2808.96 | 2 | 0.1% |
| 2434.25 | 2 | 0.1% |
| 1928.75 | 2 | 0.1% |
| 3264 | 2 | 0.1% |
| Other values (2875) | 2979 |
| Value | Count | Frequency (%) |
| 481.5 | 1 | |
| 529.35 | 1 | |
| 531 | 1 | |
| 546.66 | 1 | |
| 553.52 | 1 | |
| 557.6 | 1 | |
| 577.6 | 1 | |
| 597.4 | 1 | |
| 615 | 1 | |
| 625.5 | 1 |
| Value | Count | Frequency (%) |
| 11503.14 | 1 | |
| 11170.52 | 1 | |
| 10723.6 | 1 | |
| 10460.16 | 1 | |
| 10286.4 | 1 | |
| 10072 | 1 | |
| 9974.4 | 1 | |
| 9712.04 | 1 | |
| 9571.08 | 1 | |
| 9568.73 | 1 |
origin
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.6 KiB |
| spain | |
|---|---|
| japan | 137 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | spain |
|---|---|
| 2nd row | spain |
| 3rd row | spain |
| 4th row | spain |
| 5th row | spain |
Common Values
| Value | Count | Frequency (%) |
| spain | 2864 | |
| japan | 137 | 4.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| spain | 2864 | |
| japan | 137 | 4.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3138 | |
| p | 3001 | |
| n | 3001 | |
| s | 2864 | |
| i | 2864 | |
| j | 137 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15005 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 3138 | |
| p | 3001 | |
| n | 3001 | |
| s | 2864 | |
| i | 2864 | |
| j | 137 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15005 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 3138 | |
| p | 3001 | |
| n | 3001 | |
| s | 2864 | |
| i | 2864 | |
| j | 137 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15005 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 3138 | |
| p | 3001 | |
| n | 3001 | |
| s | 2864 | |
| i | 2864 | |
| j | 137 | 0.9% |
Interactions
Correlations
| comments | customerNumber | employeeNumber | orderDate | orderLineNumber | orderNumber | origin | priceEach | quantityOrdered | requiredDate | sales_amount | shippedDate | status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| comments | 1.000 | 0.672 | 0.708 | 1.000 | 0.000 | 0.682 | 0.774 | 0.033 | 0.205 | 1.000 | 0.091 | 1.000 | 0.979 |
| customerNumber | 0.672 | 1.000 | 0.151 | 0.053 | -0.040 | -0.010 | 0.364 | -0.024 | 0.013 | 0.128 | -0.005 | 0.129 | 0.148 |
| employeeNumber | 0.708 | 0.151 | 1.000 | 0.140 | 0.003 | 0.066 | 0.999 | -0.004 | -0.034 | 0.262 | -0.022 | 0.262 | 0.104 |
| orderDate | 1.000 | 0.053 | 0.140 | 1.000 | 0.000 | 0.090 | 0.118 | 0.078 | 0.000 | 1.000 | 0.090 | 1.000 | 0.000 |
| orderLineNumber | 0.000 | -0.040 | 0.003 | 0.000 | 1.000 | -0.043 | 0.000 | -0.008 | -0.023 | 0.000 | -0.018 | 0.000 | 0.000 |
| orderNumber | 0.682 | -0.010 | 0.066 | 0.090 | -0.043 | 1.000 | 0.170 | -0.004 | 0.053 | 0.165 | 0.030 | 0.167 | 0.320 |
| origin | 0.774 | 0.364 | 0.999 | 0.118 | 0.000 | 0.170 | 1.000 | 0.038 | 0.000 | 0.374 | 0.000 | 0.373 | 0.047 |
| priceEach | 0.033 | -0.024 | -0.004 | 0.078 | -0.008 | -0.004 | 0.038 | 1.000 | 0.022 | 0.055 | 0.819 | 0.056 | 0.000 |
| quantityOrdered | 0.205 | 0.013 | -0.034 | 0.000 | -0.023 | 0.053 | 0.000 | 0.022 | 1.000 | 0.000 | 0.563 | 0.000 | 0.182 |
| requiredDate | 1.000 | 0.128 | 0.262 | 1.000 | 0.000 | 0.165 | 0.374 | 0.055 | 0.000 | 1.000 | 0.066 | 1.000 | 0.000 |
| sales_amount | 0.091 | -0.005 | -0.022 | 0.090 | -0.018 | 0.030 | 0.000 | 0.819 | 0.563 | 0.066 | 1.000 | 0.068 | 0.047 |
| shippedDate | 1.000 | 0.129 | 0.262 | 1.000 | 0.000 | 0.167 | 0.373 | 0.056 | 0.000 | 1.000 | 0.068 | 1.000 | 0.000 |
| status | 0.979 | 0.148 | 0.104 | 0.000 | 0.000 | 0.320 | 0.047 | 0.000 | 0.182 | 0.000 | 0.047 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| orderNumber | orderLineNumber | orderDate | shippedDate | requiredDate | customerNumber | employeeNumber | productCode | status | comments | quantityOrdered | priceEach | sales_amount | origin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10100 | 1 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 363 | 1216 | S24_3969 | Shipped | NaN | 49 | 35.29 | 1729.21 | spain |
| 1 | 10100 | 2 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 363 | 1216 | S18_2248 | Shipped | NaN | 50 | 55.09 | 2754.50 | spain |
| 2 | 10100 | 3 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 363 | 1216 | S18_1749 | Shipped | NaN | 30 | 136.00 | 4080.00 | spain |
| 3 | 10100 | 4 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 363 | 1216 | S18_4409 | Shipped | NaN | 22 | 75.46 | 1660.12 | spain |
| 4 | 10101 | 1 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 128 | 1504 | S18_2795 | Shipped | Check on availability. | 26 | 167.06 | 4343.56 | spain |
| 5 | 10101 | 2 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 128 | 1504 | S24_2022 | Shipped | Check on availability. | 46 | 44.35 | 2040.10 | spain |
| 6 | 10101 | 3 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 128 | 1504 | S24_1937 | Shipped | Check on availability. | 45 | 32.53 | 1463.85 | spain |
| 7 | 10101 | 4 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 128 | 1504 | S18_2325 | Shipped | Check on availability. | 25 | 108.06 | 2701.50 | spain |
| 8 | 10102 | 1 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 181 | 1286 | S18_1367 | Shipped | NaN | 41 | 43.13 | 1768.33 | spain |
| 9 | 10102 | 2 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 181 | 1286 | S18_1342 | Shipped | NaN | 39 | 95.55 | 3726.45 | spain |
| orderNumber | orderLineNumber | orderDate | shippedDate | requiredDate | customerNumber | employeeNumber | productCode | status | comments | quantityOrdered | priceEach | sales_amount | origin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2991 | 10425 | 4 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S12_4473 | In Process | NaN | 33 | 95.99 | 3167.67 | spain |
| 2992 | 10425 | 5 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S24_2840 | In Process | NaN | 31 | 31.82 | 986.42 | spain |
| 2993 | 10425 | 6 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S32_2509 | In Process | NaN | 11 | 50.32 | 553.52 | spain |
| 2994 | 10425 | 7 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S18_2319 | In Process | NaN | 38 | 117.82 | 4477.16 | spain |
| 2995 | 10425 | 8 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S18_3232 | In Process | NaN | 28 | 140.55 | 3935.40 | spain |
| 2996 | 10425 | 9 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S24_2300 | In Process | NaN | 49 | 127.79 | 6261.71 | spain |
| 2997 | 10425 | 10 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S18_2432 | In Process | NaN | 19 | 48.62 | 923.78 | spain |
| 2998 | 10425 | 11 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S32_1268 | In Process | NaN | 41 | 83.79 | 3435.39 | spain |
| 2999 | 10425 | 12 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S10_4962 | In Process | NaN | 38 | 131.49 | 4996.62 | spain |
| 3000 | 10425 | 13 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S18_4600 | In Process | NaN | 38 | 107.76 | 4094.88 | spain |
Duplicate rows
Most frequently occurring
| orderNumber | orderLineNumber | orderDate | shippedDate | requiredDate | customerNumber | employeeNumber | productCode | status | comments | quantityOrdered | priceEach | sales_amount | origin | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10104 | 2 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 141 | 1370 | S50_1514 | Shipped | NaN | 32 | 53.31 | 1705.92 | spain | 2 |
| 1 | 10410 | 2 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 357 | 1612 | S18_3136 | Shipped | NaN | 34 | 84.82 | 2883.88 | spain | 2 |
| 2 | 10413 | 6 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 175 | 1323 | S32_3207 | Shipped | Customer requested that DHL is used for this shipping | 24 | 56.55 | 1357.20 | spain | 2 |
| 3 | 10419 | 1 | 0000-00-00 | 0000-00-00 | 0000-00-00 | 382 | 1401 | S18_1589 | Shipped | NaN | 37 | 100.80 | 3729.60 | spain | 2 |
| 4 | 10425 | 3 | 0000-00-00 | NaN | 0000-00-00 | 119 | 1370 | S18_2238 | In Process | NaN | 28 | 147.36 | 4126.08 | spain | 2 |